Enterprise Database Systems
Prepare and Process Data in Power BI
Data Preparation and Processing: Loading & Transforming Data in Power BI
it_dfppbi_02_enus
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
it_dfppbi_03_enus
Data Preparation and Processing: Using Power BI for Data Analysis
it_dfppbi_01_enus
Data Preparation and Processing: Loading & Transforming Data in Power BI
Lesson Objectives
Data Preparation and Processing: Loading & Transforming Data in Power BI
- discover the key concepts covered in this course
- download and install Power BI desktop
- connect to and import data from an Excel file into Power BI
- import data from CSV and XML files into Power BI and recall the role of Power Query in transforming the data
- load data from a JSON file into Power BI
- import data from a relational database and load it into Power BI
- remove unnecessary columns and rows from a data source using Power Query
- modify the types of columns in a table using Power Query
- merge the contents of two related columns in Power Query
- summarize the key concepts covered in this course
Overview/Description
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data. Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information. Upon completion, you'll be able to load data into Power BI and transform it for analysis.
Target
Prerequisites: none
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
Lesson Objectives
Data Preparation and Processing: Preparing Data for Visualizations in Power BI
- discover the key concepts covered in this course
- connect to data sources that are related but stored in separate files and load them into Power BI
- use Power BI's column profiling feature to recognize what information is stored in a dataset
- perform a join operation to merge two related tables into a single unit
- load data from multiple separate but related files located in a single directory
- perform aggregations on data in a table to summarize the contents of a dataset
- apply the M formula language to perform data transformations in Power BI
- filter out unnecessary data by defining row-level filters
- create a basic column chart to visualize data in Power BI
- connect to a relational database in DirectQuery mode
- build a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BI
- summarize the key concepts covered in this course
Overview/Description
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations. Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows. Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals. Upon completion, you'll be able to prepare data for visualization using a variety of transformations.
Target
Prerequisites: none
Data Preparation and Processing: Using Power BI for Data Analysis
Lesson Objectives
Data Preparation and Processing: Using Power BI for Data Analysis
- discover the key concepts covered in this course
- list the Power BI data analysis skills tested in the DA-100 certification exam
- outline the steps involved before, during, and after taking the DA-100 certification exam
- define what's meant by data analysis, distinguish it from business analytics, describe some of the crucial tasks involved in this process, and name several types of analytics
- identify the different job roles involved in data analysis and summarize the scope of each role
- list the tasks involved in data analysis that result in the transformation of raw data into meaningful visuals and reports
- recognize the features and components of Power BI used to simplify data analysis tasks
- recall the primary features and capabilities of Power BI and summarize how they facilitate data analysis tasks
- summarize the key concepts covered in this course
Overview/Description
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
Most businesses have an enormous amount of data in their possession. But this data is only as valuable as the quality of the processes used to understand it. So how do you gather seemingly disparate data from multiple sources and turn it into digestible insights for all to use? One way to do this is to use Power BI, Microsoft's business analytics service. Use this course to comprehend exactly what's involved in data analysis, including specific tasks and job roles. Examine how Power BI's suite of features can facilitate these tasks efficiently and effectively. Furthermore, see the steps involved in taking the DA-100 certification exam, which tests the learner's ability to analyze data using Power BI. Upon completion, you'll have a theoretical understanding of how Power BI is used to carry out data analysis.
Target
Prerequisites: none
